$this->db->group_by(array("title", "date")); // Produces: GROUP BY title, date
$names = array('Frank', 'Todd', 'James'); $this->db->where_not_in('username', $names); // Produces: WHERE username NOT IN ('Frank', 'Todd', 'James')